/*
 Navicat Premium Data Transfer

 Source Server         : hadoop
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : localhost:3306
 Source Schema         : book

 Target Server Type    : MySQL
 Target Server Version : 80023
 File Encoding         : 65001

 Date: 11/07/2023 22:20:04
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `role` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '角色',
  `nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '真实姓名',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `contactNumber` varchar(255) DEFAULT NULL COMMENT '联系电话',
  `registTime` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_user
-- ----------------------------
BEGIN;
INSERT INTO `admin_user` (`id`, `username`, `password`, `role`, `nickname`, `avatar`, `email`, `contactNumber`, `registTime`) VALUES (1, 'admin', 'f315515a2ce0a887dd1cc0e00cdca0e4', 'admin', 'admin', 'https://www.youbaobao.xyz/mpvue-res/logo.jpg', NULL, NULL, NULL);
INSERT INTO `admin_user` (`id`, `username`, `password`, `role`, `nickname`, `avatar`, `email`, `contactNumber`, `registTime`) VALUES (23, '123', 'f315515a2ce0a887dd1cc0e00cdca0e4', 'user', '123', '', '562868736@qq.com', '18725228898', '1679902987671');
INSERT INTO `admin_user` (`id`, `username`, `password`, `role`, `nickname`, `avatar`, `email`, `contactNumber`, `registTime`) VALUES (22, 'admin123', 'f315515a2ce0a887dd1cc0e00cdca0e4', 'user', '123', '', '67777@qq.com', '18725226715', '1646376891944');
INSERT INTO `admin_user` (`id`, `username`, `password`, `role`, `nickname`, `avatar`, `email`, `contactNumber`, `registTime`) VALUES (21, '测试', 'f315515a2ce0a887dd1cc0e00cdca0e4', 'user', 'ceshi', '', '562868736@qq.com', '18725227814', '1631235937051');
COMMIT;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `categoryName` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` (`id`, `categoryName`) VALUES (1, '通知公告');
INSERT INTO `category` (`id`, `categoryName`) VALUES (2, '热点话题');
INSERT INTO `category` (`id`, `categoryName`) VALUES (3, '校园话题');
INSERT INTO `category` (`id`, `categoryName`) VALUES (4, '学习天地');
COMMIT;

-- ----------------------------
-- Table structure for contents
-- ----------------------------
DROP TABLE IF EXISTS `contents`;
CREATE TABLE `contents` (
  `fileName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `href` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `level` int DEFAULT NULL,
  `text` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `navId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`fileName`,`navId`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of contents
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for entry_form
-- ----------------------------
DROP TABLE IF EXISTS `entry_form`;
CREATE TABLE `entry_form` (
  `id` int NOT NULL AUTO_INCREMENT,
  `enroll_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `post_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '岗位代码',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `ethnic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名族',
  `date_of_birth` varchar(255) NOT NULL COMMENT '出生年月',
  `politics_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '政治面貌及加入时间',
  `education_background` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学历',
  `degree` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学位',
  `school_and_date_of_graduation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '毕业学校及时间',
  `what_specific` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所学专业',
  `main_specialties` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '主要特长	',
  `Current_Registered_Household` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '现户口所在地',
  `current_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '现居住地',
  `ID_card_No` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份证号码',
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '本人照片',
  `achievement` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '现在研究方向及主要成果',
  `resume` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '本人主要简历',
  `contact_way` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系方式',
  `post` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '报考岗位',
  `enroll_img` varchar(2555) DEFAULT NULL COMMENT '上传的证明材料',
  `enroll_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '报名状态',
  `graduation_time` varchar(255) DEFAULT NULL COMMENT '毕业时间',
  `enroll_adminuser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',
  `politics_status_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '加入党团时间',
  `fx` varchar(255) DEFAULT NULL COMMENT '现居住地是否中高风险地区',
  `ljs` varchar(255) DEFAULT NULL COMMENT '14天内是否国内中高风险或近1个月内境外旅居史',
  `ljsbz` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '如有：14天内是否国内中高风险或近1个月内境外旅居史进行详细说明',
  `zhicheng` varchar(255) DEFAULT NULL COMMENT '职称',
  `zpyq` varchar(255) DEFAULT NULL COMMENT '是否阅读招聘要求',
  `zhichengjibie` varchar(255) DEFAULT NULL COMMENT '职称级别',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of entry_form
-- ----------------------------
BEGIN;
INSERT INTO `entry_form` (`id`, `enroll_name`, `post_code`, `sex`, `ethnic`, `date_of_birth`, `politics_status`, `education_background`, `degree`, `school_and_date_of_graduation`, `what_specific`, `main_specialties`, `Current_Registered_Household`, `current_address`, `ID_card_No`, `photo`, `achievement`, `resume`, `contact_way`, `post`, `enroll_img`, `enroll_status`, `graduation_time`, `enroll_adminuser`, `politics_status_time`, `fx`, `ljs`, `ljsbz`, `zhicheng`, `zpyq`, `zhichengjibie`) VALUES (12, '测试', '202102001', '男', '汉族', '1970.03.10', '中共党员', '专科', '博士', '云南大学', '系统分析与集成', '无', '芒市', 'null', '533124199204122733', 'null', '无', '无', '18725227814', '教学岗位', '[]', '已提交', '2019.07.01', 'admin', '2016.09.05', '否', '否', '无', '正高级', 'true', NULL);
INSERT INTO `entry_form` (`id`, `enroll_name`, `post_code`, `sex`, `ethnic`, `date_of_birth`, `politics_status`, `education_background`, `degree`, `school_and_date_of_graduation`, `what_specific`, `main_specialties`, `Current_Registered_Household`, `current_address`, `ID_card_No`, `photo`, `achievement`, `resume`, `contact_way`, `post`, `enroll_img`, `enroll_status`, `graduation_time`, `enroll_adminuser`, `politics_status_time`, `fx`, `ljs`, `ljsbz`, `zhicheng`, `zpyq`, `zhichengjibie`) VALUES (13, '宋东翔', '202102001', '男', '汉族', '2015.10.13', '中共党员', '研究生', '硕士', '云南大学', '体育民族学', '足球', '对对对', 'null', '533124199204122733', 'null', '无', '无', '18725227814', '教学岗位', '[]', '终审通过', '2018.10.16', 'admin123', '2022.10.17', '否', '否', '无', 'null', 'null', NULL);
INSERT INTO `entry_form` (`id`, `enroll_name`, `post_code`, `sex`, `ethnic`, `date_of_birth`, `politics_status`, `education_background`, `degree`, `school_and_date_of_graduation`, `what_specific`, `main_specialties`, `Current_Registered_Household`, `current_address`, `ID_card_No`, `photo`, `achievement`, `resume`, `contact_way`, `post`, `enroll_img`, `enroll_status`, `graduation_time`, `enroll_adminuser`, `politics_status_time`, `fx`, `ljs`, `ljsbz`, `zhicheng`, `zpyq`, `zhichengjibie`) VALUES (14, '哈哈哈', '202301001', '女', '壮族', '1994.03.15', '农工党党员', '硕士研究生', '博士', '22fgsdfgsdfgs', '22', '111', '无', 'null', '533124199204122733', 'null', '11', '11', '18725227814', '专业技术岗位', '[{\"name\":\"fa0632c0c66a63965c0201c1ddd131c2_fullsize.jpeg\",\"url\":\"https://www.dhszzp.top/admin-upload-ebook/enroll/aee5e8124cfd07ed28821e5247a900a2.jpg\"},{\"name\":\"宋东翔.jpg\",\"url\":\"https://www.dhszzp.top/admin-upload-ebook/enroll/9096cabd71515ca8f599babff2d99f0a.jpg\"}]', '已提交', '2023.03.05', 'admin', '无', '无', '无', '无', '111', 'true', '正高级');
INSERT INTO `entry_form` (`id`, `enroll_name`, `post_code`, `sex`, `ethnic`, `date_of_birth`, `politics_status`, `education_background`, `degree`, `school_and_date_of_graduation`, `what_specific`, `main_specialties`, `Current_Registered_Household`, `current_address`, `ID_card_No`, `photo`, `achievement`, `resume`, `contact_way`, `post`, `enroll_img`, `enroll_status`, `graduation_time`, `enroll_adminuser`, `politics_status_time`, `fx`, `ljs`, `ljsbz`, `zhicheng`, `zpyq`, `zhichengjibie`) VALUES (15, '123', '202301001', '男', '苗族', '1989.09.04', '民建会员', '硕士研究生', '硕士', '31231', '3123', '123', '无', 'null', '533124199204122733', 'null', 'JJ', '123', '18725227814', '专业技术岗位', '[]', '已提交', '2020.03.02', 'admin', '无', '无', '无', '无', '123', 'true', '中级');
COMMIT;

-- ----------------------------
-- Table structure for examine
-- ----------------------------
DROP TABLE IF EXISTS `examine`;
CREATE TABLE `examine` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `examine_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '被审核用户',
  `examine_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核时间',
  `examine_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核状态',
  `examine_explain` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '审核说明',
  `examine_operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核用户',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of examine
-- ----------------------------
BEGIN;
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (66, '测试', '1631238240986', '已提交', '报名表保存并提交，等待初审', '测试');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (67, '测试', '1631243464307', '初审通过', '系统简单过滤审核报名信息格式正确，学历、学位、年龄、专业符合202102001岗位', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (68, '测试', '1631245123928', '终审通过', '系统自动审核通过，图像识别身份证获取信息：张三、男、汉族、500000000000000；学位证获取信息：硕士、张三、系统分析与集成、2020年6月8日；学历证获取信息：研究生、张三、系统分析与集成、2020年6月8日；', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (69, '测试', '1646098815267', '已提交', '报名表修改保存并提交，等待初审', '测试');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (70, '测试', '1646102060587', '已提交', '报名表修改保存并提交，等待初审', '测试');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (71, 'admin', '1646105052986', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (72, 'admin', '1646124527336', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (73, 'admin', '1646124576521', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (74, 'admin', '1646125020660', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (75, 'admin', '1646125484646', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (76, 'admin', '1646125622552', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (77, 'admin', '1646126242397', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (78, 'admin', '1646126371576', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (79, 'admin', '1646126380201', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (80, 'admin', '1646126589312', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (81, 'admin', '1646126804282', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (82, 'admin', '1646127063881', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (83, 'admin', '1646127100189', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (84, 'admin', '1646127177943', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (85, 'admin', '1646127250394', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (86, 'admin', '1646127263589', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (87, 'admin', '1646127432984', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (88, 'admin', '1646317571585', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (89, 'admin123', '1665536445436', '已提交', '报名表保存并提交，等待初审', 'admin123');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (90, 'admin123', '1665536741486', '初审通过', '系统信息过滤岗位、民族、学历、学位、所学专业信息审核通过岗位202102001', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (91, 'admin123', '1665537041515', '终审通过', '系统通过自动化审核，识别身份证、学位证、毕业证信息与报名表信息一致，审核通过。', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (92, 'admin', '1679899662829', '已提交', '报名表保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (93, 'admin', '1679900184632', '初审通过', '1112', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (94, 'admin', '1679904791720', '已提交', '报名表修改保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (95, 'admin', '1679904939362', '已提交', '报名表保存并提交，等待初审', 'admin');
INSERT INTO `examine` (`id`, `examine_name`, `examine_time`, `examine_status`, `examine_explain`, `examine_operator`) VALUES (96, 'admin', '1680167599926', '已提交', '报名表修改保存并提交，等待初审', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for hot_book
-- ----------------------------
DROP TABLE IF EXISTS `hot_book`;
CREATE TABLE `hot_book` (
  `id` int NOT NULL AUTO_INCREMENT,
  `openId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `fileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_dt` bigint DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fileName` (`fileName`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=6043 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of hot_book
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for hot_search
-- ----------------------------
DROP TABLE IF EXISTS `hot_search`;
CREATE TABLE `hot_search` (
  `openId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `keyword` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_dt` bigint DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `keyword` (`keyword`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=445 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of hot_search
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `columnid` varchar(255) NOT NULL,
  `attribute` varchar(255) NOT NULL DEFAULT '0',
  `abstract` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `photo` varchar(2555) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0',
  `body` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sort` int NOT NULL DEFAULT '0',
  `visit` int NOT NULL DEFAULT '0',
  `state` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1',
  `date` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of news
-- ----------------------------
BEGIN;
INSERT INTO `news` (`id`, `title`, `columnid`, `attribute`, `abstract`, `photo`, `body`, `sort`, `visit`, `state`, `date`) VALUES (16, '1234', '校园话题', 'true', '222', 'http://localhost:8080/admin-upload-ebook/news/5380d71bb6cbe19e44640040c5bd18a8.jpg', '22222', 0, 22222, '1', 0);
INSERT INTO `news` (`id`, `title`, `columnid`, `attribute`, `abstract`, `photo`, `body`, `sort`, `visit`, `state`, `date`) VALUES (17, '555', '通知公告', 'true', '555', 'http://localhost:8080/admin-upload-ebook/news/8e761ec5f95cf34dd06a7904910d5f7f.jpg', '555', 0, 555, '1', 0);
INSERT INTO `news` (`id`, `title`, `columnid`, `attribute`, `abstract`, `photo`, `body`, `sort`, `visit`, `state`, `date`) VALUES (21, '123', '热点话题', '0', '2222', 'http://localhost:8080/admin-upload-ebook/news/66c0ad72d0268b707e936495fbf747e2.jpg', '![7.jpg]()', 0, 0, '1', 0);
INSERT INTO `news` (`id`, `title`, `columnid`, `attribute`, `abstract`, `photo`, `body`, `sort`, `visit`, `state`, `date`) VALUES (20, '11', '学习天地', 'true', '222', 'http://localhost:8080/admin-upload-ebook/news/f6803d0c716504c80f251f8ba3e93094.jpg', '222', 0, 11, '1', 0);
INSERT INTO `news` (`id`, `title`, `columnid`, `attribute`, `abstract`, `photo`, `body`, `sort`, `visit`, `state`, `date`) VALUES (22, '666', '通知公告', 'true', '6666', 'http://localhost:8080/admin-upload-ebook/news/undefined.jpg,http://localhost:8080/admin-upload-ebook/news/undefined.jpg,http://localhost:8080/admin-upload-ebook/news/undefined.jpg', '6666', 0, 666, '1', 0);
INSERT INTO `news` (`id`, `title`, `columnid`, `attribute`, `abstract`, `photo`, `body`, `sort`, `visit`, `state`, `date`) VALUES (23, '777', '热点话题', 'true', '777', 'http://localhost:8080/admin-upload-ebook/news/http://localhost:8080/admin-upload-ebook/news/undefined..jpg,http://localhost:8080/admin-upload-ebook/news/http://localhost:8080/admin-upload-ebook/news/undefined..jpg,http://localhost:8080/admin-upload-ebook/news/http://localhost:8080/admin-upload-ebook/news/undefined..jpg', '777', 0, 777, '1', 0);
INSERT INTO `news` (`id`, `title`, `columnid`, `attribute`, `abstract`, `photo`, `body`, `sort`, `visit`, `state`, `date`) VALUES (24, '职业	初中生', '热点话题', 'true', '职业	初中生', 'http://localhost:8080/admin-upload-ebook/news/3.jpg.jpg,http://localhost:8080/admin-upload-ebook/news/4.jpg.jpg,http://localhost:8080/admin-upload-ebook/news/6.jpg.jpg,http://localhost:8080/admin-upload-ebook/news/2.jpg.jpg,http://localhost:8080/admin-upload-ebook/news/7.jpg.jpg,http://localhost:8080/admin-upload-ebook/news/5.jpg.jpg', '职业	初中生', 0, 888, '1', 0);
INSERT INTO `news` (`id`, `title`, `columnid`, `attribute`, `abstract`, `photo`, `body`, `sort`, `visit`, `state`, `date`) VALUES (25, '999', '通知公告', 'true', '999', 'http://localhost:8080/admin-upload-ebook/news/8.jpg,http://localhost:8080/admin-upload-ebook/news/4.jpg,http://localhost:8080/admin-upload-ebook/news/6.jpg,http://localhost:8080/admin-upload-ebook/news/5.jpg,http://localhost:8080/admin-upload-ebook/news/2.jpg,http://localhost:8080/admin-upload-ebook/news/7.jpg,http://localhost:8080/admin-upload-ebook/news/3.jpg', '999', 0, 999, '1', 0);
COMMIT;

-- ----------------------------
-- Table structure for plan
-- ----------------------------
DROP TABLE IF EXISTS `plan`;
CREATE TABLE `plan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `unit` varchar(255) DEFAULT NULL COMMENT '招聘单位名称',
  `postCode` varchar(255) DEFAULT NULL COMMENT '岗位代码',
  `postName` varchar(255) DEFAULT NULL COMMENT '岗位名称',
  `jobNum` int DEFAULT NULL COMMENT '招聘人数',
  `education` varchar(255) DEFAULT NULL COMMENT '学历学位',
  `xuewei` varchar(255) DEFAULT NULL COMMENT '学位',
  `age` varchar(255) DEFAULT NULL COMMENT '年龄',
  `major` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '专业',
  `condition` text COMMENT '其它招聘条件',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of plan
-- ----------------------------
BEGIN;
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (1, '德宏师范高等专科学校', '202301001', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '体育学（0403）；体育（0452）', '体操方向；健美操方向', NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (2, '德宏师范高等专科学校', '202301002', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '音乐学（1302L1）；音乐（135101；音乐与舞蹈学（130200）（音乐方向）；艺术（135100）（音乐方向）', '本科阶段专业为音乐学、音乐表演或音乐与作曲理论专业', NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (3, '德宏师范高等专科学校', '202301003', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '美术学（130400）；美术（135107）；艺术（135100）', '油画方向', NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (4, '德宏师范高等专科学校', '202301004', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '音乐与舞蹈学（130200）（舞蹈方向）；舞蹈（135106）', '本科阶段专业为舞蹈编导或舞蹈表演专业', NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (5, '德宏师范高等专科学校', '202301005', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '车辆工程（080204）、动力机械及工程（080703）、交通运输工程（082300）（汽车方向）、载运工具运用工程（082304）（汽车方向）、动力工程及工程热物理 （080700）（内燃机方向）、机械工程（080200）（汽车或电动汽车方向）', NULL, NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (6, '德宏师范高等专科学校', '202301006', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '美术学（130400）；美术（135107）', '书法方向', NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (7, '德宏师范高等专科学校', '202301007', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '数字媒体技术（0810Z1或0812Z2)，艺术设计(135108)（数字媒体艺术、数字媒体与影视动画设计、数媒与影像数字化、视觉传达、摄影与数字媒体艺术、视觉与交互、动画与数字媒体艺术方向），设计学(087200或130500）（数字媒体艺术研究、数字媒体艺术、视觉传达与媒体设计方向），艺术（135100）（数字媒体设计、视觉传达设计制作方向），艺术学理论（130100）（艺术原理研究方向）', NULL, NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (8, '德宏师范高等专科学校', '202301008', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '大数据技术与工程（085411）、计算机技术（085404）、网络与信息安全（085412）、网络信息安全（0812J2）、信息安全（0812Z1或0810Z1）、网络空间安全（083900）、计算机软件与理论（081202）、计算机系统结构（081201）、计算机应用技术（081203或077503）、计算机科学与技术（081200或077500）、系统分析与集成（071102）、数据科学与工程（0835Z4）、信息与通信工程（081000）', NULL, NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (9, '德宏师范高等专科学校', '202301009', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '财务管理（1202Z1）、电子商务（1202Z2）、工商管理（120200或125100）；金融学（020204）、金融（025100）、税务（025300）、统计学（020208或02700或071400）、应用统计（025200或0714Z2或0714Z3或0714Z4）、应用统计学（0714Z4）、社会经济统计（0714Z1）、大数据统计（0714Z3或0714J2）；国际贸易学（020206）、技术经济学（0202Z4）', NULL, NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (10, '德宏师范高等专科学校', '202301010', '专业技术岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '图书情报与档案管理（1205）；图书情报（1255）；中国语言文学（0501）', NULL, NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (11, '德宏师范高等专科学校', '202301011', '管理岗位\n', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '刑法学（030104）、诉讼法学（030106）、民商法学（030105）；审计（025700）、审计学（1202Z1或1202Z2或1202Z3或1202Z7）；新闻学（050301）、传播学（050302）、新闻传播学（050300）、新闻与传播（055200）；心理学（040200或077100）、心理健康教育（045116）、应用心理学（040203或077103）、应用心理（045400）；学前教育学（040105）、学前教育（045118）', NULL, NULL);
INSERT INTO `plan` (`id`, `unit`, `postCode`, `postName`, `jobNum`, `education`, `xuewei`, `age`, `major`, `condition`, `remark`) VALUES (12, '德宏师范高等专科学校', '202301012', '管理岗位', 1, '硕士研究生及以上', '硕士及以上', '18周岁以上、35周岁以下，博士或具有中级职称的原则上在40周岁以下，具有高级职称的原则上不超过50周岁', '基础数学（070101）、计算数学（070102）、应用数学（070104）、概率论与数理统计（070103）；艺术设计（135108或1304Z1）、设计学（130500或087200）、设计艺术学（1305L1）、艺术（135100）（艺术设计、室内设计方向）；运动人体科学（040302）、体育教学（045201）、体育教育训练学（040303）、运动训练（045202）；美术学（130400）、美术（135107）；作物栽培与耕作学（090101）、作物遗传育种（090102）、作物学（090100）、果树学（090201）、蔬菜学（090202）、观赏园艺学（0902Z1或0902Z2或0902Z4）、园艺学（090200）', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for rank
-- ----------------------------
DROP TABLE IF EXISTS `rank`;
CREATE TABLE `rank` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `openId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `rank` int DEFAULT NULL,
  `create_dt` bigint DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=559 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of rank
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for shelf
-- ----------------------------
DROP TABLE IF EXISTS `shelf`;
CREATE TABLE `shelf` (
  `fileName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `openId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `date` bigint DEFAULT NULL,
  PRIMARY KEY (`openId`,`fileName`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of shelf
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sign
-- ----------------------------
DROP TABLE IF EXISTS `sign`;
CREATE TABLE `sign` (
  `id` int NOT NULL AUTO_INCREMENT,
  `openId` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_dt` bigint NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `openId` (`openId`,`create_dt`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=502 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sign
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `openId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `avatarUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `country` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `gender` int DEFAULT NULL,
  `language` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `nickName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `province` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_dt` bigint DEFAULT NULL,
  `update_dt` bigint DEFAULT NULL,
  `platform` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user_openId` (`openId`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=916 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `openId`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `province`, `create_dt`, `update_dt`, `platform`, `phone`) VALUES (5, '1111', 'https://ss1.bdstatic.com/70cFvXSh_Q1YnxGkpoWK1HF6hhy/it/u=3627762979,343242720&fm=26&gp=0.jpg', NULL, NULL, NULL, NULL, '夏小一', NULL, NULL, NULL, 'wx', NULL);
INSERT INTO `user` (`id`, `openId`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `province`, `create_dt`, `update_dt`, `platform`, `phone`) VALUES (6, '2222', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1558879364419&di=5afdf69938b3f5fe1b23de34ad932919&imgtype=0&src=http%3A%2F%2Fimg4.duitang.com%2Fuploads%2Fblog%2F201307%2F29%2F20130729185848_EPksn.thumb.700_0.jpeg', NULL, NULL, NULL, NULL, '夏小二', NULL, NULL, NULL, 'wx', NULL);
INSERT INTO `user` (`id`, `openId`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `province`, `create_dt`, `update_dt`, `platform`, `phone`) VALUES (7, '3333', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1559474099&di=4f031bf15b1433f8987af50861173c25&imgtype=jpg&er=1&src=http%3A%2F%2Fimg5q.duitang.com%2Fuploads%2Fblog%2F201307%2F29%2F20130729190043_v2SU8.thumb.700_0.jpeg', NULL, NULL, NULL, NULL, '夏小三', NULL, NULL, NULL, 'wx', NULL);
INSERT INTO `user` (`id`, `openId`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `province`, `create_dt`, `update_dt`, `platform`, `phone`) VALUES (8, '4444', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1559474113&di=c605143d9d8296d442aa969392849e15&imgtype=jpg&er=1&src=http%3A%2F%2Fimg4.duitang.com%2Fuploads%2Fblog%2F201307%2F29%2F20130729185912_Pfxvm.thumb.700_0.jpeg', NULL, NULL, NULL, NULL, '夏小四', NULL, NULL, NULL, 'wx', NULL);
INSERT INTO `user` (`id`, `openId`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `province`, `create_dt`, `update_dt`, `platform`, `phone`) VALUES (9, '5555', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1558879406226&di=f0db6c19f93d5686eed86f9b575da16b&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201212%2F27%2F20121227182600_SZZGr.thumb.700_0.jpeg', NULL, NULL, NULL, NULL, '夏小五', NULL, NULL, NULL, 'wx', NULL);
INSERT INTO `user` (`id`, `openId`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `province`, `create_dt`, `update_dt`, `platform`, `phone`) VALUES (10, '6666', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1558879414672&di=115fb66809c2d39f7fcc17824ed872a4&imgtype=0&src=http%3A%2F%2Fimg.duoziwang.com%2F2016%2F10%2F05%2F2025006696.jpg', NULL, NULL, NULL, NULL, '夏小六', NULL, NULL, NULL, 'wx', NULL);
INSERT INTO `user` (`id`, `openId`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `province`, `create_dt`, `update_dt`, `platform`, `phone`) VALUES (11, '7777', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1559474147&di=4b444abbbe0f22a8e0e40e0b9c706244&imgtype=jpg&er=1&src=http%3A%2F%2Fhbimg.b0.upaiyun.com%2Fb2c1740a81fd05e7bfb6baf1ba88bf20982da25cb9cd-YWeaM7_fw658', NULL, NULL, NULL, NULL, '夏小七', NULL, NULL, NULL, 'wx', NULL);
INSERT INTO `user` (`id`, `openId`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `province`, `create_dt`, `update_dt`, `platform`, `phone`) VALUES (12, '8888', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1558879441491&di=ff28c284ad1a1c3a2b8535040ea15506&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201212%2F24%2F20121224182211_TjGem.jpeg', NULL, NULL, NULL, NULL, '夏小八', NULL, NULL, NULL, 'wx', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
